Product documentation
In This Topic
    Product Search FAQ's
    In This Topic

    Frequently asked questions

    Question: What is the relation between the product’s sales price and the layout price field?
    Answer: There is no direct relation between any price field in the system and the price field to be shown on the result card. Using the field search queries for a product item, you can retrieve the sales price (as a list price) or the purchase price from the released product for example. For one specific price field you can emphasize it as the price field (including a price currency symbol) on the result card.
    Question: Is it possible to display the result of a calculated field on the result card?
    Answer:

    Yes, you can add fields to the layout definitions that are calculated at the moment the search result is fetched. This can be used for information such as On-hand inventory and Margin. A few calculated fields are made available, but almost any needed calculation can be added by a developer.

    Question: Can we also use the regular column filters in combination with Product Search?
    Answer: This is not supported as part of the product. When opening the Product search results in a listpage, the regular column filters can be used to further filter the result. However, we advise against it, as it is not possible to use a combination of Product search and regular column filters for saved searches on tiles (or lists/links on the workspace). The Product search filters are the only ones that are applied for the tile and the count on the tile will represent that. Taking the additional regular column filters into account would heavily impact performance and is therefore not supported. We highly recommend to handle any additional filtering needs via Product search (especially if the required filter would be recurring), as it is both supported and much quicker, so adjustments to the Product search setup if needed make more sense. The regular column filters should only be used for occasional further filtering of Product search results on very rarely needed filters.  
    Question: I got a message about an invalid expression during usage of Product Search?
    Answer:

    Using the Product Search function a message appears:
    Invalid expression: Could not find a property named 'xxx' on type 'yyy'. Parameter name: $select


    Please first have a look within the Product information management parameters > tab Advanced Search.

    On the tab General two buttons are available: Search layout definitions and Search filter definitions.

    If necessary, please first delete the definition with the named property and publish the definitions again.
    See Product Information management > Periodic tasks > Advanced search > Publish definitions

    Question: Does changing the category attribute value on the category need an update to Azure Search?
    Answer: Changing the value of the category attribute values do not need a publish of the definitions again. However, an update of the search data (both scheme and data) is required here.
    Question: I get a message saying there are missing search layout definition fields?
    Answer:

    When a message appears about missing search layout definition fields, then the field DYSASBLayoutDefinitionId is empty. The product is using a default layout definition containing ID and Description, as a fall back layout definition. This layout definition will be generated automatically during the update of the search data, so there is no real definition available.

    Question: How to disable the default Product Search form during entering an item number?
    Answer:

    Microsoft Dynamics 365 for Finance and Operations behavior is to open the default Product Search form automatically, when you are leaving the item number field during a non-complete line input. Using the Azure Product Search function, this behavior is probably not wanted:

    To disable this behavior, you can switch off the Trade item search function within your configuration key settings.

    Question: When trying to access the details of a product from the Released products search form, I get a message that I don't have the required permissions.  
    Answer: This means that you do not have the security access rights to the (standard MS) details form the system is trying to open. Please contact your system administrator to assign additional (standard MS) rights to your account.
    Question: Why is Product search no longer working after a database refresh (from another environment), giving a 'this menu item cannot be opened' error?
    Answer:

    The authentication information in an environment get's stored as an encrypted value with an encryption key from the original environment. When a database copy gets restored into a different environment, the encryption key is no longer valid and the connection to the Azure service cannot be made. To resolve this, refill the Search key in the Azure connections form (when using 'String' type authentication) or refill the Key vault key under the Key vault settings (when using 'Key vault). Use the 'Validate' button on the Azure search services form to check if the connection is restored, after which Product search should work as expected again.  

    Please note that when copying a database, especially from a production environment, it is needed to adjust the index as well, to prevent it pointing to the index from the origin environment (to prevent updating the Production index with test data).